
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Agurto, Jorge>
-- Create date: <05/11/2011>
-- =============================================
CREATE PROCEDURE [GOOGLECODERS].BeneficiarioInsert 
	@RazonSocial varchar(255),
	@DirCalle varchar(255),
	@DirNro int,
	@DirPiso int = NULL,
	@DirDepto varchar(2) = NULL,
	@IdRubro int
AS
BEGIN
	SET NOCOUNT ON;

	INSERT INTO [GOOGLECODERS].Beneficiarios
	VALUES(@RazonSocial,
			@DirCalle,
			@DirNro,
			@DirPiso,
			@DirDepto,
			@IdRubro,
			1)
	
	SELECT @@IDENTITY
END
GO